Tabela WHExam

Definicja tabeli WHExam

Name

WHExam

Code

WHExam

Comment

Archiwum histopatologiczne


Lista kolumn tabeli WHExam

Name

Code

WHExamID

WHExamID

ExamNumber

ExamNumber

FirstName

FirstName

LastName

LastName

Age

Age

OrderingEntity

OrderingEntity

DocumentationNo

DocumentationNo

PerfDT

PerfDT

DescribingPerson

DescribingPerson

Classification

Classification

Active

Active

InsertPersonID

InsertPersonID

InsertDT

InsertDT

UpdatePersonID

UpdatePersonID

UpdateDT

UpdateDT

Material

Material

MaterialRegistrationDT

MaterialRegistrationDT

ClinicalData

ClinicalData

PreviousExams

PreviousExams

ExamResult

ExamResult

Legend

Legend

ResultDT

ResultDT


Kolumna WHExamID tabeli WHExam

Definicja kolumny WHExamID tabeli WHExam

Name

WHExamID

Code

WHExamID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExamNumber tabeli WHExam

Definicja kolumny ExamNumber tabeli WHExam

Name

ExamNumber

Code

ExamNumber

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FirstName tabeli WHExam

Definicja kolumny FirstName tabeli WHExam

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Imie
EN: First Name
DE: der Name


Kolumna LastName tabeli WHExam

Definicja kolumny LastName tabeli WHExam

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Nazwisko
EN: Last name
DE: der Nachname


Kolumna Age tabeli WHExam

Definicja kolumny Age tabeli WHExam

Name

Age

Code

Age

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna OrderingEntity tabeli WHExam

Definicja kolumny OrderingEntity tabeli WHExam

Name

OrderingEntity

Code

OrderingEntity

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna DocumentationNo tabeli WHExam

Definicja kolumny DocumentationNo tabeli WHExam

Name

DocumentationNo

Code

DocumentationNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli WHExam

Definicja kolumny PerfDT tabeli WHExam

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DescribingPerson tabeli WHExam

Definicja kolumny DescribingPerson tabeli WHExam

Name

DescribingPerson

Code

DescribingPerson

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Classification tabeli WHExam

Definicja kolumny Classification tabeli WHExam

Name

Classification

Code

Classification

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli WHExam

Definicja kolumny Active tabeli WHExam

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertPersonID tabeli WHExam

Definicja kolumny InsertPersonID tabeli WHExam

Name

InsertPersonID

Code

InsertPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli WHExam

Definicja kolumny InsertDT tabeli WHExam

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna UpdatePersonID tabeli WHExam

Definicja kolumny UpdatePersonID tabeli WHExam

Name

UpdatePersonID

Code

UpdatePersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdateDT tabeli WHExam

Definicja kolumny UpdateDT tabeli WHExam

Name

UpdateDT

Code

UpdateDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Material tabeli WHExam

Definicja kolumny Material tabeli WHExam

Name

Material

Code

Material

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna MaterialRegistrationDT tabeli WHExam

Definicja kolumny MaterialRegistrationDT tabeli WHExam

Name

MaterialRegistrationDT

Code

MaterialRegistrationDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ClinicalData tabeli WHExam

Definicja kolumny ClinicalData tabeli WHExam

Name

ClinicalData

Code

ClinicalData

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna PreviousExams tabeli WHExam

Definicja kolumny PreviousExams tabeli WHExam

Name

PreviousExams

Code

PreviousExams

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna ExamResult tabeli WHExam

Definicja kolumny ExamResult tabeli WHExam

Name

ExamResult

Code

ExamResult

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna Legend tabeli WHExam

Definicja kolumny Legend tabeli WHExam

Name

Legend

Code

Legend

Data Type

CLOB

Mandatory

No

Comment

szczególy opis materialu z pola material


Kolumna ResultDT tabeli WHExam

Definicja kolumny ResultDT tabeli WHExam

Name

ResultDT

Code

ResultDT

Data Type

DATE

Mandatory

No

Comment

data wprowadzenia wyniku


Lista kluczy tabeli WHExam

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WHExam

Definicja klucza Identifier_1 tabeli WHExam

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment